StartAtCharsCSVs
 
Description

If the ImportFieldOpApplyTo<N> field contains a comma-separated list of strings (for example, file names), StartAtCharsCSVs allows you to import each listed string from a specified character onwards. Enter one of the following for ImportFieldOpParam<N> to determine up to which character the individual string is discarded:

<character>,0
Deletes the strings listed in the ImportFieldOpApplyTo<N> field up to the first instance of the specified <character>.

<character>,1
Deletes the strings listed in the ImportFieldOpApplyTo<N> field up to the last instance of the specified <character>.

<character>,2
Deletes the first instance of the specified <character> from each string listed in the ImportFieldOpApplyTo<N> field, and each string up to this character.

<character>,3
Deletes the last instance of the specified <character> from each string listed in the ImportFieldOpApplyTo<N> field, and each string up to this character.

Example

ImportFieldOpApplyTo0=MyField
ImportFieldOp0=StartAtCharsCSVs

In this example, if the MyField field contains the string temp/test/files,mydocuments/archive,current/save/QA, part of this string is deleted as follows, depending on ImportFieldOpParam0:

ImportFieldOpParam0="/",0
The MyField field is imported with the value /test/files,/archive,/save/QA.

ImportFieldOpParam0="/",1
The MyField field is imported with the value /files,/archive,/QA.

ImportFieldOpParam0="/",2
The MyField field is imported with the value test/files,archive,save/QA.

ImportFieldOpParam0="/",3
The MyField field is imported with the value files,archive,QA.

IMPORTANT: Any character placed in quotes that has a special function in the C language must also be escaped by placing a backslash in front of it. For example, \ must be entered as \\.

See also

EndAtChars

StartAtChars