Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Colleagues, good day!
I have one field, which contain information about delivery days.
For example, if delivery days are Monday, Tuesday - value is MT.
Friday, Saturday- FS.
How i can convert such symbol combination into days concat.
Maybe, it's possible by concat function, which can read string per symbol?
Necessary result:
DelDays | Result by exp |
F | Friday |
T | Tuesdat |
MW | Monday, Wednesday |
Su | Sunday |
MTWTh | Monday, Tuesday, Wednesday, Thursday |
You can use MapSubString in that case. Try this,
Map:
Mapping LOAD * INLINE [
Short, Full
M, ", Monday"
T, ", Tuesday"
W, ", Wednesday"
Th, ", Thursday"
F, ", Friday"
S, ", Saturday"
Su, ", Sunday"
];
Tab:
LOAD DelDays, Mid(MapSubString('Map',DelDays),3) as Result
INLINE [
DelDays
F
T
MW
Su
MTWTh
];
Hi,
Try:
Load * Inline [
DelDays , Result
F, Friday
T, Tuesdat
MW ,"Monday, Wednesday"
Su ,Sunday
MTWTh, "Monday, Tuesday, Wednesday, Thursday"
];
Thanks,
AS
Like This,
Make sure, You have List box you can write this expression in Expression Tab.
Hope Helpful...
=If(DelDays = 'F','Friday',
If(DelDays = 'T','Thursday',
If(DelDays = 'MW','Monday, Wednesday',
If(DelDays = 'SU','Sunday',
If(DelDays = 'MTWT','Monday, Tuesday, Wednesday, Thursday',)
)
)
)
)
Use a if() to create the field is possible to do the outcome FYR:Creating a new field with IF statement Hope It helps!
see this
Directory;
LOAD *,
Pick(match(DelDays,'F','MTWT','MW','Su','T'),'Friday','Monday, Tuesday, Wednesday, Thursday','Monday, Wednesday','Sunday','Tuesday') as Days;
LOAD DelDays
FROM
Test.xlsx
(ooxml, embedded labels, table is Лист1);
Thanks.
But i mean some automatic checking by these symbol combination.
I have more than 60 such combination and i need write condition for each of them (count of these conditions can grow)
I think mine answer is not helpful
Nai yaar... esa nai hai... bahut helpful hai
Kushal,
Not like that, What ever poster expecting we are giving the solutions. He didn't release any thing about what he is looking.
Meantime, That is not a problem - Whoever poster he just release BTA. If he tell something hints then we can try.
- Anil Chowdary
You can use MapSubString in that case. Try this,
Map:
Mapping LOAD * INLINE [
Short, Full
M, ", Monday"
T, ", Tuesday"
W, ", Wednesday"
Th, ", Thursday"
F, ", Friday"
S, ", Saturday"
Su, ", Sunday"
];
Tab:
LOAD DelDays, Mid(MapSubString('Map',DelDays),3) as Result
INLINE [
DelDays
F
T
MW
Su
MTWTh
];