RegEx with dynamic/varying length

Question

Hi all,

I need to parse a long string that has some fixed and variable characters.

For the fixed characters, I use (\w{#}), but for the variable characters I am looking for a solution.

For example, all the characters in the following string are fixed, except for the red characters, which can vary from 1-24 characters (including white spaces).

XXXX XXX X X X XXXXXXXXXXXXXXXXXXXXXXXX XX XX XX XXXXXXXX XXXXXXXX XXXXXX

Would appreciate any assistance!

DanAAC · Answer

@binu_acs

Please see attached. It's essentially the same as in my original post. But I am using RegEx to parse one column that contains a string into multiple columns. The only problem is that the part in red is not fixed.

Sample Data.xlsx

DanAAC · Answer

Thank you!

I am not sure this is what I am looking for. I am going to parse the ENTIRE string, not just the string in red. But the string in red is not fixed.

I am using RegEx to parse the string into columns.

binu_acs · Answer

@DanAAC Can you provide a sample data?