Hi Team,
I've the data like below and I'm using below input tool configuration to read the data since it has a missing closing quote.
and then I'm using Text to columns to split into multiple columns basis (|) as delimiter and using Dynamic rename to get the column names.
Case1: If I use below config for Text to column tool, the data point (Row1 and Row2) are fine but Row 3 is giving incorrect values
Case2: if I use below config for Text to Columns, the data point (Row1 and Row4) are fine but Row 3 is giving incorrect values
Can you please suggest how we can handle both the cases together since the dataset is one.
Below is the expected output.
Good finding. 😁
I eventually made a rather messy flow.
I replaced the quote before or after the | with special characters which are believed not to appear.
@Shaaz, if your use case is limited to the sample data you have shared then try this solution if it fits your use case.
PS: This is one of the solutions.
I hope this helps!
Thanks!
Hi @Shaaz
Another easy method of doing this. Attached workflow for your reference.
Thanks
Rohit Gupta
@Kurohits
I think the requestor still wants to keep the quote characters. 😁
Hi @Shaaz
I have regex function to match groups. You can check out this solution. I hope this will work.
Thanks
Rohit Gupta