NDM: Splitting Dataset name of large length in to 2 lines

krisprems · Posted: Wed Nov 28, 2007 12:02 am

Hi
I have a NDM Connect Direct step..
I need a Syntax to split the File name(Wich is greater than 72 bytes) in to two lines,

superk · Posted: Wed Nov 28, 2007 1:44 am

How about breaking the string into tokens, then concatenating the tokens together?

krisprems · Posted: Wed Nov 28, 2007 10:37 am

Thank you very much, this solved most of my problem...
But what about the single quotes...that is

krisprems · Posted: Wed Nov 28, 2007 4:00 pm

I got the soultion for splitting the file name in to two lines without using SYMBOL's.

This is the Correct SYNATX

swapnadeep.ganguly · Active User Joined: 21 Mar 2007 Posts: 203 Location: India

Hi krisprems,

I am facing the same problem as yours. But the solution that you have provided is not working for me. Can you please look into the matter???

dick scherrer · Posted: Wed Jan 30, 2008 9:20 pm

Hello,

swapnadeep.ganguly · Active User Joined: 21 Mar 2007 Posts: 203 Location: India

Hi Dick,

I was able to solve the matter.

Basically I was going wrong in one part. The code that helped me out is as under:

dick scherrer · Posted: Thu Jan 31, 2008 9:16 pm

Cool - thanks for letting us know

d

Steve Elliott · Posted: Fri Feb 15, 2008 10:58 am

Here is the method for splitting paths with backslashes over multiple lines:

1) Double all the backslashes eg: \\\\Server\\folder1\\folder2\\file.txt

2) Split the line as many times as you need (anywhere except in the
middle of two backslashes)
eg:
\\\\Server\\fold
er1\\folder
2\\file.txt

3) Then:
add \' in front of the first line
add \ in front of all other lines
add '\ at the end of the last line
add \ || at the end of all previous lines
include the continuation character as normal.

eg:
\'\\\\Server\\fold\ || -
\er1\\folder\ || -
\2\\file.txt'\ -

This even works if you have spaces in your folder names, and even when the space is at the end or start of a line.

The same logic can also be used in the run task see example below:

RUNSTEP1 RUN TASK (PGM="WINNT") -
SYSOPTS= -
\'\\\\Server\\fold\ || -
\er1\\folder\ || -
\2\\file.bat'\ -
SNODE

It took me around 150 attempts to figure this out, so hopefully it will be of use for someone else.

swapnadeep.ganguly · Active User Joined: 21 Mar 2007 Posts: 203 Location: India

Hi Steve,

It was very kind of you to post your solution. Kudos to you.

dick scherrer · Posted: Sat Feb 16, 2008 12:53 am

Hello Steve and welcome to the forums,

Thank you for posting your "path split" method.

pravena · New User Joined: 31 Jan 2007 Posts: 9 Location: chennai

Hi Steve,
Thanks for ur superb explanation.
it's very useful

KARTHIGADEVI · New User Joined: 07 Sep 2017 Posts: 4 Location: Singapore

This can also do..

&OUT01=\'/datastage/data/XXXX_XXXX_XXX/Loss/src/\|| -
\XXXXXXXX.XXXXXXXX.XXXX.REINGRP.DAT'\ -

Robert Sample · Posted: Tue Dec 05, 2017 6:24 pm

KARTHIGADEVI, after almost NINE YEARS, I really doubt your post will have much impact. PLEASE look at the last post date before adding anything to any topic -- if the last post date was more than a few months ago, it is unlikely you can add anything of value to that topic.

sapfisher · New User Joined: 17 Aug 2017 Posts: 3 Location: usa

Robert Sample,
Actually, I was googling this topic and found the old messages and it WAS very helpful.

Thanks!

Nic Clouston · Posted: Sat Mar 17, 2018 2:39 am