Substitute special characters with regsub in Importmaster

Hi all,

I'm facing the following problem:

In an attribute of a dimension element there is a line feed included within other text. No idea how the LF came into this attribute, but it is there.

To use the value of this attribute in a SQL-statement I have to replace the LF otherwise the SQL-Statement becomes invalid.

My challenge is to find the correct regsub-statement in Importmaster.

Already tried various things as regsub -all "\n" $attribute "" attribute_clean but couldn't find the correct way to do it and the IM-documentation does not help either.

Can anyone help how to replace special characters (ascii code < 32) in general in Importmaster TCL-script?

Thanks for any tips,

Ralf

Find more posts tagged with

Infor EPM Discussions

Comments

David Swinburne

Hi Ralf,

Try this:

set foo a
b
puts $foo
regsub -all {
} $foo {} bar
puts $bar

Logging application: Infor d/EPM ImportMaster V9.5.3.1
Import started at 22 Apr 2022 15:20:56.
---------------------------------------------------
Loading Script DLL
C:Program Files (x86)Common FilesCubewarecwscript85.dll V9.5.2.13
---------------------------------------------------
Script: Starting jobs at 22 Apr 2022 15:20:56
Execute script: Script - Started at 22 Apr 2022 15:20:56
a
b
ab
---------------------------------------------------
Freeing resources
Import completed
Import finished at 22 Apr 2022 15:20:56

does not require escaping in TCL.

Regards

Dave

Ralf Zerfass

Hi Dave,

thanks for the tip, however, it does not work on my side.

I checked all codes of every single character in the attribute and indeed the code of the character causing the problem is 10, so seems to be a LF...

Any idea how to replace the character with code 10 (instead of
) by a blank or nothing?

Regards,

Ralf

David Swinburne

HI Ralf,

is equivalent to an ASCII 10 so I am surprised the result was not as expected.

An alternative could be to explicitly reference the hexadecimal representation of an ASCII 10.

set foo a
b
puts $foo
regsub -all {x0A} $foo {} bar
puts $bar

Regards

Dave

Ralf Zerfass

Hi Dave,

it's kind of weird...

When reading the attribute in Office Plus and scanning the characters, I find the ascii(10).

When reading the attribute in IM with GetAttrib and scanning the characters, I get this:

Steuerabzüge auf Zinsen^nGeben Sie Text oder eine W

So finally I succeeded with the following:

regsub -all {^n} $att "" attneu

Very strange, why the
is converted to a ^n

Anyway, thanks for your help and your patience,

Stay well,

Ralf

Copyright © 2025 Infor. All rights reserved.