Oct 21, 2011 #1 C1704 IS-IT--Management Joined Oct 20, 2011 Messages 1 Location GB I have a query! MC74LVX4052DT|74LVX4052 (Input) MC74LVX4052DT|74LVX4052|MC|DT (Output) How do i get in unix & excel
I have a query! MC74LVX4052DT|74LVX4052 (Input) MC74LVX4052DT|74LVX4052|MC|DT (Output) How do i get in unix & excel
Oct 21, 2011 #2 feherke Programmer Joined Aug 5, 2002 Messages 9,541 Location RO Hi C1704 said: I have a query! Click to expand... Where is it ? C1704 said: MC74LVX4052DT|74LVX4052 (Input) MC74LVX4052DT|74LVX4052|MC|DT (Output) Click to expand... What do you want ? To generate that output from the input is enough the shell itself : Code: [blue]master #[/blue] var='MC74LVX4052DT|74LVX4052' [blue]master #[/blue] IFS='|' [blue]master #[/blue] set -- $var [blue]master #[/blue] echo "$*|${1:0:2}|${1: -2}" MC74LVX4052DT|74LVX4052|MC|DT C1704 said: How do i get in unix & excel Click to expand... How would be Excel involved in this ? Anyway, as Microsoft never released Excel for Unix, this part is pointless. Feherke. Upvote 0 Downvote
Hi C1704 said: I have a query! Click to expand... Where is it ? C1704 said: MC74LVX4052DT|74LVX4052 (Input) MC74LVX4052DT|74LVX4052|MC|DT (Output) Click to expand... What do you want ? To generate that output from the input is enough the shell itself : Code: [blue]master #[/blue] var='MC74LVX4052DT|74LVX4052' [blue]master #[/blue] IFS='|' [blue]master #[/blue] set -- $var [blue]master #[/blue] echo "$*|${1:0:2}|${1: -2}" MC74LVX4052DT|74LVX4052|MC|DT C1704 said: How do i get in unix & excel Click to expand... How would be Excel involved in this ? Anyway, as Microsoft never released Excel for Unix, this part is pointless. Feherke.