Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have one list box like below attached file. I want to show that list box name without doing any selections.How can we achieve that.
Kindly give me solutions ASAP.
Plz Find below attached file.
Hi Nagarjuna,
Try like this
Sample Script;
LOAD
@1 AS DieselPriceText,
Date(Date#(Mid(@1, Index(@1, ',') + 2), 'MMMM D, YYYY')) AS Date,
Mid(@1, 1,
Index(@1, 'Rs/Ltr') + 6) AS Price,
Mid(@1, Index(@1, ':') + 2) AS DATE_FORMAT
FROM
[mypetrolprice.com/3/Diesel-price-in-Mumbai]
(html, utf8, no labels, table is @10)
WHERE @1 Like 'Mumbai*';
Expression for List box:
=FirstSortedValue(Price, -Date) & ' Most recent changed date : ' & FirstSortedValue(DATE_FORMAT, -Date)
Please find attached file for solution.
Regards,
Jagan.
Requirement is not clear. Describe your problem with more explanation for the getting better responses.
try this,
No,Not like that shiva. I want that Entaire name in text box without doing any selections.
Thanks in Advance
i think just u can put ur list box field in ur text,tht will give the expected result..i think so.
else pls share ur app with expected output?
I guess this is what you are looking for:
Maybe:
Create a group-->Add only this field to this group.

The in textbox:
=GetCurrentField(Amount)

In my example the Field and Group names are the same but you can use diffrent
Hi Nagarjuna,
If you attach sample data then it would be easier to give the solution.
Regards,
jagan.
The sample data is already included in my suggestion for a solution - since it was easy to Google to find it... so it is simply a LOAD .... FROM [http://.....];
LOAD
@1 AS DieselPriceText
FROM
[http://www.mypetrolprice.com/3/Diesel-price-in-Mumbai]
(html, utf8, no labels, table is @10)
WHERE @1 Like 'Mumbai*';
Hi Nagarjuna,
Try like this
Sample Script;
LOAD
@1 AS DieselPriceText,
Date(Date#(Mid(@1, Index(@1, ',') + 2), 'MMMM D, YYYY')) AS Date,
Mid(@1, 1,
Index(@1, 'Rs/Ltr') + 6) AS Price,
Mid(@1, Index(@1, ':') + 2) AS DATE_FORMAT
FROM
[mypetrolprice.com/3/Diesel-price-in-Mumbai]
(html, utf8, no labels, table is @10)
WHERE @1 Like 'Mumbai*';
Expression for List box:
=FirstSortedValue(Price, -Date) & ' Most recent changed date : ' & FirstSortedValue(DATE_FORMAT, -Date)
Please find attached file for solution.
Regards,
Jagan.