Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one value field without delimiter
I want to divide the value into three middle left and right values.
Could anyone help me
Best regards
Maurice
Hi, which characters are used to create the blank spaces? spaces or tabs?
Having some values on the right without anything before, and having some values in the middle one with like looks that there are more than one separator I only see the option the define wich star character will **bleep** as the middle and wich one would count data as right.
Using a mix of Trim(), Subfield(), Mid() and Index() I think it may be done, the most tricky is the firsts ones that only have all empty spaces and data on the right
Hi, which characters are used to create the blank spaces? spaces or tabs?
Having some values on the right without anything before, and having some values in the middle one with like looks that there are more than one separator I only see the option the define wich star character will **bleep** as the middle and wich one would count data as right.
Using a mix of Trim(), Subfield(), Mid() and Index() I think it may be done, the most tricky is the firsts ones that only have all empty spaces and data on the right