span8
span4
span8
span4
Hi I am wondering how would I manipulate multiple dates in a single fusion table cell so that it would improve its readability.I would be uploading this data onto a map and would be using html.I was thinking to utilise the break tag to split each line of date to the next line.Any help would be greatly appreciated thanks lots.fusion-table.jpgweb.jpg
i used on a bit of the value in the operating hours column in your posted jpg.
This regexp in the stringreplacer:
([\d\/]+\s*\w+:\s\w+\-\w+)
and i use replace \1@ ( for i am not sure i see a ";"in the column,hard to see due to low res)
then a splitter with delimiter @
Gets all in a nice list.
Assuming that every date is formatted with "d/m/yy" always,this expression returns a string containing only dates separated by space(s).
@ReplaceRegEx(@ReplaceRegEx(@Value(OPERATING_HOURS),[^\s\d/]+,""),\s\d+\s,"")
The inside @ReplaceRegEx function replaces every character except {space,digits,slash} with the empty string.The outside one replaces every "
You can use the expression in the AttributeCreator (Value column) or StringConcatenator.Then,if necessay,you can split the resulting string with the AttributeSplitter to split the string into each date.
Unfortunately each date is not formatted in d/m/yy as it has the day of the week and the time,thanks!
ah,it seems that each date entry consists of these elements separated by space.
Isn't it?
If so,the StringReplacer can be used to replace every space between different entries with a specific character (e.g.a pipe "|").
Then,split the string by the specified character with the AttributeSplitter.
[Edited the regex]
© 2019 亚搏在线Safe Software Inc |法律