Re^3: Splitting a long row with multiple delimiters.

Is it safe to assume that keys not followed by = sign are null? If so, how would you define a key?

For example: key1=abcd key2 key3=123

What is actually expected output? This one?

key1=abcd key2
key3=123
[download]

Or this one?

key1=abcd
key2=null
key3=123
[download]

How do you recognize null keys inside the string? Should key2 be treated as key, or is it actually part of value to be stored in key1?

Comment on Re^3: Splitting a long row with multiple delimiters. Select or Download Code

Replies are listed 'Best First'.
Re^4: Splitting a long row with multiple delimiters. by dipit (Sexton) on Jan 19, 2018 at 14:52 UTC
yes the keys which donot have "=" (in this case only first value) or have "key=<whitespace>",value will be considered as null or undef.	[reply]
Re^5: Splitting a long row with multiple delimiters. by poj (Abbot) on Jan 19, 2018 at 15:13 UTC
Do all the keys which do not have "=" appear at the beginning of the string ? poj	[reply]
Re^6: Splitting a long row with multiple delimiters. by dipit (Sexton) on Jan 19, 2018 at 16:29 UTC
Yes Buddy, fortunately, its only in beginning and that too only single string.	[reply]
Re^7: Splitting a long row with multiple delimiters. by poj (Abbot) on Jan 19, 2018 at 16:50 UTC
Re^7: Splitting a long row with multiple delimiters. by tybalt89 (Monsignor) on Jan 19, 2018 at 17:33 UTC