Speech Mark Woes

Help Studio
1

I have some text I need removing using Excel Activities Find/Replace

{“DynamicProperties”:{

Written exactly as it is above. I have tried adding triple speech marks, breaking it down into component parts and remove them, this is ok for part but removes other sections of the file

Any recommendations :slight_smile:

2

HI @rmorgan

Have you given the specific range in the activity?

Regards
Gokul

3

Hi @rmorgan ,

Could you provide us with an Example Data of What is the Input and what would be the output after performing the operation ? If you could provide screenshots of the Inputs and Outputs it would be much easier to understand and provide a better suggestion/approach.

4

Each Row looks as the below orchestrator transaction item
{“DynamicProperties”:{“out_Guid”:“60fb81d9-e3ae-4876-ae51-311324743460”,“out_ApplicationNo”:“12089757”,“out_PatenetNo”:“7922968”,“out_AttorneyDocket”:“”,“out_FeeCode”:“1553”,“out_FeeAmount”:“7700”,“out_FeeCode1”:“”,“out_FeeAmount1”:“”,“out_ScrapedFeeCode”:“1553”,“out_ScrapedFeeAmount”:“7700.00”,“out_ScrapedFeeCode1”:“”,“out_ScrapedFeeAmount1”:“”,“out_TransactionID”:“E202209713152502”,“out_TransactionTotal”:“$7,700.00”,“out_SubTotal”:“$7700.00”

I just need rid of the {“DynamicProperties”:{ at the begining so i can text to columns the rest

5

All data is in the A:A range and that is specified
image
The above doesn’t even remove it :frowning:

6

Can you try inserting: Chr (34) for each Quotation mark?

ASCII Library Links
Library Link #1

Library Link #2

Hopefully this helps :blush:

Cheers

Steve

7

Obviously I didn’t mess around with it enough :man_shrugging: Thanks

8

No worries :blush:

There is a method I believe to the additional quotation marks. And you were on the right track! Try adding 4 sets of Quotation mark each side (total 8). I think this worked for me didn’t play around with it enough to commit it to memory :sweat_smile:

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.