I’m not an expert, but you could use regex expressions here.
For instance, if you would like to extract the sys id from any string similar with the above one, the you could use something like: (?<=sys_id”:“)(.*)(?=”,“number”) source: regex101: build, test, and debug regex
By replacing the boundary strings (sys_id”:“ & ”,“number”), you can extract what ever you would like
@ppr@prasath17@MUTHUKUMAR_RAMACHANDRAN@Marius_Puscasu
i need one more help
i have a string
Recently our Distribution lists are not automatically updated ( for the past 2 months)
I have to contact ITTICS support for every new joiners or transfers.
Could you please fix this issue for the future?
but i need every thing in none line to pass the input how can i make all the line in one line
as mentioned depends on your linebreak.
debug for us, and show us the string details from locals, watch or immediate panel
or tell us the details from where the string is coming from
other options are
Split on \r - vbCr
Split on \n vbLf
@ppr can u try this text copying in one of the excel
Recently our Distribution lists are not automatically updated ( for the past 2 months)
I have to contact ITTICS support for every new joiners or transfers.
Could you please fix this issue for the future?
any test from our side would not replicate your scenario:
the screenshots from above (immediate panel) was done on a excel readin with linebreak
and the \n was replaceable.
Same suggestion show us the details from your end e.g. from debug /watch /immediate panel.
Another thing is that now the line break removal is now away from original topic. Better is to keep the topics thread not mixed up (will help researchers for similar cases). Keep this topic for the JSON / text retrieval. And feel free to open a new topic for the Linebreak removal. Thanks