HomeForum
Welcome, Guest

Problem to create TXT file (from Excel and Literal
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Problem to create TXT file (from Excel and Literal

Problem to create TXT file (from Excel and Literal 2 years, 7 months ago #720

  • acury
  • OFFLINE
  • Junior Boarder
  • Posts: 20
  • Karma: 0
Hi !

I´m try create a TXT file (realy a .BAT file), the command is fixed, but the machines is variant (to update), i´m edit a Excel file, in the file i have 72 machine names, in the transformation the design is here:

Literal: xcopy \\server\share\folter\file.dll \\ -> JOINER 1
FIELD (From Excel): MACHINE001 -> JOINER 2
Literal: \C$\windows\system32 /y -> JOINER 3

The result of the joiner: xcopy \\server\share\folter\file.dll \\ MACHINE001 \C$\windows\system32 /y

See the space after and before machine name ? this space cause error in command, i´m try use (in JOINER 2) TRIM, DELETE SPACES, but the spaces insist in write on the output file ..

Help-me !!!

Tanks

Alexandre Cury

Re:Problem to create TXT file (from Excel and Literal 2 years, 7 months ago #722

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Alexandre

We have reproduced the problem and currently looking what can be done about it

Peter

Re:Problem to create TXT file (from Excel and Literal 2 years, 6 months ago #723

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Alexandre

It was fixed in the latest version of Advanced ETL Processor

Peter

Re:Problem to create TXT file (from Excel and Lite 2 years, 6 months ago #725

  • acury
  • OFFLINE
  • Junior Boarder
  • Posts: 20
  • Karma: 0
HI !

Worked perfect !

Tanks !
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

Development team listens to it's customers and implements new features in days sometimes hours.

Paul Gibb,
MPS

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top