Problem with text format win-1252 and extract character from order number

Hello.
I have question. Is any chance to in “format as text” with “conjure text based file conjurer” use win-1252? Now file is in utf-8.

Second question is how i can “extract” character from order number.

80% orders is like “12345678” and this is text field. Some orders have character “R” like “R12345678”.

I need in “format as text” list to separate R from order number to another column but only when R exist. If R doesnt exist, use only order number and second column need to be empty.

Anybody can help?

This topic was automatically closed after 70 days. New replies are no longer allowed.